Skip to main content

Re-running data

To re-run data in TIM Enterprise, follow the steps below:

  1. Take a copy of the data you want to re-run back in the system, stored by default in the backup folder of the main installation program.
{Program Files}\Tri-Line\TIM Enterprise\backup

  1. Log in to TIM Enterprise as a root user and click on the SQL tab.

  2. To check the datasource for the PBX object you want to delete calls for, enter the following query:

SELECT name, fullkey from dir where type = 'pbx';

fullkey

  1. To delete calls for a specific PBX object and a specific time period, enter the following query:
DELETE from calls 
WHERE datasource = '\8\9\'
AND 
datetime between '2023-01-01 00:00:00' AND '2023-02-01 00:00:00';
info

The datasource and datetime values must be modified accordingly, in order to match your requirements for the time period and the PBX object you want to delete calls for.

  1. The query should return a X rows returned (X ms) message, confirming the selected calls have been deleted.

no results

  1. To re-spool the data back in the system, copy the previously-saved backup files and paste them into the following location:
{Program Files}\Tri-Line\TIM Enterprise\spool
  1. Whilst the system is processing the data, you can click on the Call view screen to monitor the calls that are being logged.
info

The time to re-spool the data will vary, depending on the amount and size of the files your system is processing.